Let’s see how different neighborhood matrix styles can impact the estimates of spatial regression models. Again, run the code below in order to have the data in place for this exercises.
## Reading layer `OGRGeoJSON' from data source
## `https://geoportal.stadt-koeln.de/arcgis/rest/services/Basiskarten/kgg/MapServer/20/query?where=objectid+is+not+null&text=&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&distance=&units=esriSRUnit_Foot&relationParam=&outFields=*&returnGeometry=true&returnTrueCurves=false&maxAllowableOffset=&geometryPrecision=&outSR=4326&havingClause=&returnIdsOnly=false&returnCountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&returnZ=false&returnM=false&gdbVersion=&historicMoment=&returnDistinctValues=false&resultOffset=&resultRecordCount=&returnExtentOnly=false&datumTransformation=¶meterValues=&rangeValues=&quantizationParameters=&featureEncoding=esriDefault&f=geojson'
## using driver `GeoJSON'
## Simple feature collection with 543 features and 20 fields
## Geometry type: MULTIPOLYGON
## Dimension: XY
## Bounding box: xmin: 6.77253 ymin: 50.83045 xmax: 7.162028 ymax: 51.08496
## Geodetic CRS: WGS 84
## ℹ Using "','" as decimal and "'.'" as grouping mark. Use `read_delim()` for more control.
## Rows: 949 Columns: 79
## ── Column specification ──────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
## Delimiter: ";"
## chr (3): wahl, ags, gebiet-name
## dbl (71): gebiet-nr, max-schnellmeldungen, anz-schnellmeldungen, A1, A2, A3, A, B, B1, C, D, E, F, D1, F1, D2, F2, D3, F3, D4, F4, D5, F5, D6, F6, D7,...
## lgl (4): D30, F30, D31, F31
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
##
|
| | 0%
|
|= | 0%
|
|= | 1%
|
|== | 1%
|
|== | 2%
|
|=== | 2%
|
|==== | 3%
|
|===== | 3%
|
|===== | 4%
|
|====== | 4%
|
|======= | 5%
|
|======== | 5%
|
|======== | 6%
|
|========= | 6%
|
|========== | 7%
|
|=========== | 7%
|
|=========== | 8%
|
|============ | 8%
|
|============ | 9%
|
|============= | 9%
|
|============== | 9%
|
|============== | 10%
|
|=============== | 10%
|
|=============== | 11%
|
|================ | 11%
|
|================= | 12%
|
|================== | 12%
|
|================== | 13%
|
|=================== | 13%
|
|==================== | 14%
|
|===================== | 14%
|
|===================== | 15%
|
|====================== | 15%
|
|======================= | 16%
|
|======================== | 16%
|
|======================== | 17%
|
|========================= | 17%
|
|========================= | 18%
|
|========================== | 18%
|
|=========================== | 18%
|
|=========================== | 19%
|
|============================ | 19%
|
|============================ | 20%
|
|============================= | 20%
|
|============================== | 21%
|
|=============================== | 21%
|
|=============================== | 22%
|
|================================ | 22%
|
|================================= | 23%
|
|================================== | 23%
|
|================================== | 24%
|
|=================================== | 24%
|
|==================================== | 25%
|
|===================================== | 25%
|
|===================================== | 26%
|
|====================================== | 26%
|
|====================================== | 27%
|
|======================================= | 27%
|
|======================================== | 27%
|
|======================================== | 28%
|
|========================================= | 28%
|
|========================================= | 29%
|
|========================================== | 29%
|
|=========================================== | 30%
|
|============================================ | 30%
|
|============================================ | 31%
|
|============================================= | 31%
|
|============================================== | 32%
|
|=============================================== | 32%
|
|=============================================== | 33%
|
|================================================ | 33%
|
|================================================ | 34%
|
|================================================= | 34%
|
|================================================== | 34%
|
|================================================== | 35%
|
|=================================================== | 35%
|
|=================================================== | 36%
|
|==================================================== | 36%
|
|===================================================== | 36%
|
|===================================================== | 37%
|
|====================================================== | 37%
|
|====================================================== | 38%
|
|======================================================= | 38%
|
|======================================================== | 39%
|
|========================================================= | 39%
|
|========================================================= | 40%
|
|========================================================== | 40%
|
|========================================================== | 41%
|
|=========================================================== | 41%
|
|============================================================ | 41%
|
|============================================================ | 42%
|
|============================================================= | 42%
|
|============================================================= | 43%
|
|============================================================== | 43%
|
|=============================================================== | 43%
|
|=============================================================== | 44%
|
|================================================================ | 44%
|
|================================================================ | 45%
|
|================================================================= | 45%
|
|================================================================== | 45%
|
|================================================================== | 46%
|
|=================================================================== | 46%
|
|=================================================================== | 47%
|
|==================================================================== | 47%
|
|==================================================================== | 48%
|
|===================================================================== | 48%
|
|====================================================================== | 48%
|
|====================================================================== | 49%
|
|======================================================================= | 49%
|
|======================================================================= | 50%
|
|======================================================================== | 50%
|
|========================================================================= | 50%
|
|========================================================================= | 51%
|
|========================================================================== | 51%
|
|========================================================================== | 52%
|
|=========================================================================== | 52%
|
|============================================================================ | 52%
|
|============================================================================ | 53%
|
|============================================================================= | 53%
|
|============================================================================= | 54%
|
|============================================================================== | 54%
|
|============================================================================== | 55%
|
|=============================================================================== | 55%
|
|================================================================================ | 55%
|
|================================================================================ | 56%
|
|================================================================================= | 56%
|
|================================================================================= | 57%
|
|================================================================================== | 57%
|
|=================================================================================== | 57%
|
|=================================================================================== | 58%
|
|==================================================================================== | 58%
|
|==================================================================================== | 59%
|
|===================================================================================== | 59%
|
|====================================================================================== | 59%
|
|====================================================================================== | 60%
|
|======================================================================================= | 60%
|
|======================================================================================= | 61%
|
|======================================================================================== | 61%
|
|========================================================================================= | 62%
|
|========================================================================================== | 62%
|
|========================================================================================== | 63%
|
|=========================================================================================== | 63%
|
|=========================================================================================== | 64%
|
|============================================================================================ | 64%
|
|============================================================================================= | 64%
|
|============================================================================================= | 65%
|
|============================================================================================== | 65%
|
|============================================================================================== | 66%
|
|=============================================================================================== | 66%
|
|================================================================================================ | 66%
|
|================================================================================================ | 67%
|
|================================================================================================= | 67%
|
|================================================================================================= | 68%
|
|================================================================================================== | 68%
|
|=================================================================================================== | 69%
|
|==================================================================================================== | 69%
|
|==================================================================================================== | 70%
|
|===================================================================================================== | 70%
|
|====================================================================================================== | 71%
|
|======================================================================================================= | 71%
|
|======================================================================================================= | 72%
|
|======================================================================================================== | 72%
|
|======================================================================================================== | 73%
|
|========================================================================================================= | 73%
|
|========================================================================================================== | 73%
|
|========================================================================================================== | 74%
|
|=========================================================================================================== | 74%
|
|=========================================================================================================== | 75%
|
|============================================================================================================ | 75%
|
|============================================================================================================= | 76%
|
|============================================================================================================== | 76%
|
|============================================================================================================== | 77%
|
|=============================================================================================================== | 77%
|
|================================================================================================================ | 78%
|
|================================================================================================================= | 78%
|
|================================================================================================================= | 79%
|
|================================================================================================================== | 79%
|
|=================================================================================================================== | 80%
|
|==================================================================================================================== | 80%
|
|==================================================================================================================== | 81%
|
|===================================================================================================================== | 81%
|
|===================================================================================================================== | 82%
|
|====================================================================================================================== | 82%
|
|======================================================================================================================= | 82%
|
|======================================================================================================================= | 83%
|
|======================================================================================================================== | 83%
|
|======================================================================================================================== | 84%
|
|========================================================================================================================= | 84%
|
|========================================================================================================================== | 85%
|
|=========================================================================================================================== | 85%
|
|=========================================================================================================================== | 86%
|
|============================================================================================================================ | 86%
|
|============================================================================================================================= | 87%
|
|============================================================================================================================== | 87%
|
|============================================================================================================================== | 88%
|
|=============================================================================================================================== | 88%
|
|================================================================================================================================ | 89%
|
|================================================================================================================================= | 89%
|
|================================================================================================================================= | 90%
|
|================================================================================================================================== | 90%
|
|================================================================================================================================== | 91%
|
|=================================================================================================================================== | 91%
|
|==================================================================================================================================== | 91%
|
|==================================================================================================================================== | 92%
|
|===================================================================================================================================== | 92%
|
|===================================================================================================================================== | 93%
|
|====================================================================================================================================== | 93%
|
|======================================================================================================================================= | 94%
|
|======================================================================================================================================== | 94%
|
|======================================================================================================================================== | 95%
|
|========================================================================================================================================= | 95%
|
|========================================================================================================================================== | 96%
|
|=========================================================================================================================================== | 96%
|
|=========================================================================================================================================== | 97%
|
|============================================================================================================================================ | 97%
|
|============================================================================================================================================= | 98%
|
|============================================================================================================================================== | 98%
|
|============================================================================================================================================== | 99%
|
|=============================================================================================================================================== | 99%
|
|=============================================================================================================================================== | 100%
|
|================================================================================================================================================| 100%
##
|
| | 0%
|
|= | 0%
|
|= | 1%
|
|== | 1%
|
|== | 2%
|
|=== | 2%
|
|==== | 3%
|
|===== | 3%
|
|===== | 4%
|
|====== | 4%
|
|======= | 5%
|
|======== | 5%
|
|======== | 6%
|
|========= | 6%
|
|========== | 7%
|
|=========== | 7%
|
|=========== | 8%
|
|============ | 8%
|
|============ | 9%
|
|============= | 9%
|
|============== | 9%
|
|============== | 10%
|
|=============== | 10%
|
|=============== | 11%
|
|================ | 11%
|
|================= | 12%
|
|================== | 12%
|
|================== | 13%
|
|=================== | 13%
|
|==================== | 14%
|
|===================== | 14%
|
|===================== | 15%
|
|====================== | 15%
|
|======================= | 16%
|
|======================== | 16%
|
|======================== | 17%
|
|========================= | 17%
|
|========================= | 18%
|
|========================== | 18%
|
|=========================== | 18%
|
|=========================== | 19%
|
|============================ | 19%
|
|============================ | 20%
|
|============================= | 20%
|
|============================== | 21%
|
|=============================== | 21%
|
|=============================== | 22%
|
|================================ | 22%
|
|================================= | 23%
|
|================================== | 23%
|
|================================== | 24%
|
|=================================== | 24%
|
|==================================== | 25%
|
|===================================== | 25%
|
|===================================== | 26%
|
|====================================== | 26%
|
|====================================== | 27%
|
|======================================= | 27%
|
|======================================== | 27%
|
|======================================== | 28%
|
|========================================= | 28%
|
|========================================= | 29%
|
|========================================== | 29%
|
|=========================================== | 30%
|
|============================================ | 30%
|
|============================================ | 31%
|
|============================================= | 31%
|
|============================================== | 32%
|
|=============================================== | 32%
|
|=============================================== | 33%
|
|================================================ | 33%
|
|================================================ | 34%
|
|================================================= | 34%
|
|================================================== | 34%
|
|================================================== | 35%
|
|=================================================== | 35%
|
|=================================================== | 36%
|
|==================================================== | 36%
|
|===================================================== | 36%
|
|===================================================== | 37%
|
|====================================================== | 37%
|
|====================================================== | 38%
|
|======================================================= | 38%
|
|======================================================== | 39%
|
|========================================================= | 39%
|
|========================================================= | 40%
|
|========================================================== | 40%
|
|========================================================== | 41%
|
|=========================================================== | 41%
|
|============================================================ | 41%
|
|============================================================ | 42%
|
|============================================================= | 42%
|
|============================================================= | 43%
|
|============================================================== | 43%
|
|=============================================================== | 43%
|
|=============================================================== | 44%
|
|================================================================ | 44%
|
|================================================================ | 45%
|
|================================================================= | 45%
|
|================================================================== | 45%
|
|================================================================== | 46%
|
|=================================================================== | 46%
|
|=================================================================== | 47%
|
|==================================================================== | 47%
|
|==================================================================== | 48%
|
|===================================================================== | 48%
|
|====================================================================== | 48%
|
|====================================================================== | 49%
|
|======================================================================= | 49%
|
|======================================================================= | 50%
|
|======================================================================== | 50%
|
|========================================================================= | 50%
|
|========================================================================= | 51%
|
|========================================================================== | 51%
|
|========================================================================== | 52%
|
|=========================================================================== | 52%
|
|============================================================================ | 52%
|
|============================================================================ | 53%
|
|============================================================================= | 53%
|
|============================================================================= | 54%
|
|============================================================================== | 54%
|
|============================================================================== | 55%
|
|=============================================================================== | 55%
|
|================================================================================ | 55%
|
|================================================================================ | 56%
|
|================================================================================= | 56%
|
|================================================================================= | 57%
|
|================================================================================== | 57%
|
|=================================================================================== | 57%
|
|=================================================================================== | 58%
|
|==================================================================================== | 58%
|
|==================================================================================== | 59%
|
|===================================================================================== | 59%
|
|====================================================================================== | 59%
|
|====================================================================================== | 60%
|
|======================================================================================= | 60%
|
|======================================================================================= | 61%
|
|======================================================================================== | 61%
|
|========================================================================================= | 62%
|
|========================================================================================== | 62%
|
|========================================================================================== | 63%
|
|=========================================================================================== | 63%
|
|=========================================================================================== | 64%
|
|============================================================================================ | 64%
|
|============================================================================================= | 64%
|
|============================================================================================= | 65%
|
|============================================================================================== | 65%
|
|============================================================================================== | 66%
|
|=============================================================================================== | 66%
|
|================================================================================================ | 66%
|
|================================================================================================ | 67%
|
|================================================================================================= | 67%
|
|================================================================================================= | 68%
|
|================================================================================================== | 68%
|
|=================================================================================================== | 69%
|
|==================================================================================================== | 69%
|
|==================================================================================================== | 70%
|
|===================================================================================================== | 70%
|
|====================================================================================================== | 71%
|
|======================================================================================================= | 71%
|
|======================================================================================================= | 72%
|
|======================================================================================================== | 72%
|
|======================================================================================================== | 73%
|
|========================================================================================================= | 73%
|
|========================================================================================================== | 73%
|
|========================================================================================================== | 74%
|
|=========================================================================================================== | 74%
|
|=========================================================================================================== | 75%
|
|============================================================================================================ | 75%
|
|============================================================================================================= | 76%
|
|============================================================================================================== | 76%
|
|============================================================================================================== | 77%
|
|=============================================================================================================== | 77%
|
|================================================================================================================ | 78%
|
|================================================================================================================= | 78%
|
|================================================================================================================= | 79%
|
|================================================================================================================== | 79%
|
|=================================================================================================================== | 80%
|
|==================================================================================================================== | 80%
|
|==================================================================================================================== | 81%
|
|===================================================================================================================== | 81%
|
|===================================================================================================================== | 82%
|
|====================================================================================================================== | 82%
|
|======================================================================================================================= | 82%
|
|======================================================================================================================= | 83%
|
|======================================================================================================================== | 83%
|
|======================================================================================================================== | 84%
|
|========================================================================================================================= | 84%
|
|========================================================================================================================== | 85%
|
|=========================================================================================================================== | 85%
|
|=========================================================================================================================== | 86%
|
|============================================================================================================================ | 86%
|
|============================================================================================================================= | 87%
|
|============================================================================================================================== | 87%
|
|============================================================================================================================== | 88%
|
|=============================================================================================================================== | 88%
|
|================================================================================================================================ | 89%
|
|================================================================================================================================= | 89%
|
|================================================================================================================================= | 90%
|
|================================================================================================================================== | 90%
|
|================================================================================================================================== | 91%
|
|=================================================================================================================================== | 91%
|
|==================================================================================================================================== | 91%
|
|==================================================================================================================================== | 92%
|
|===================================================================================================================================== | 92%
|
|===================================================================================================================================== | 93%
|
|====================================================================================================================================== | 93%
|
|======================================================================================================================================= | 94%
|
|======================================================================================================================================== | 94%
|
|======================================================================================================================================== | 95%
|
|========================================================================================================================================= | 95%
|
|========================================================================================================================================== | 96%
|
|=========================================================================================================================================== | 96%
|
|=========================================================================================================================================== | 97%
|
|============================================================================================================================================ | 97%
|
|============================================================================================================================================= | 98%
|
|============================================================================================================================================== | 98%
|
|============================================================================================================================================== | 99%
|
|=============================================================================================================================================== | 99%
|
|=============================================================================================================================================== | 100%
|
|================================================================================================================================================| 100%
voting_districts <-
glue::glue(
"https://geoportal.stadt-koeln.de/arcgis/rest/services/Basiskarten/kgg/\\
MapServer/20/query?where=objectid+is+not+null&text=&objectIds=&time=&\\
geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=\\
esriSpatialRelIntersects&distance=&units=esriSRUnit_Foot&relationParam=&\\
outFields=*&returnGeometry=true&returnTrueCurves=false&maxAllowableOffset=\\
&geometryPrecision=&outSR=4326&havingClause=&returnIdsOnly=false&return\\
CountOnly=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=\\
&returnZ=false&returnM=false&gdbVersion=&historicMoment=&returnDistinct\\
Values=false&resultOffset=&resultRecordCount=&returnExtentOnly=false&datum\\
Transformation=¶meterValues=&rangeValues=&quantizationParameters=&\\
featureEncoding=esriDefault&f=geojson"
) %>%
sf::st_read(as_tibble = TRUE) %>%
sf::st_transform(3035) %>%
dplyr::transmute(Stimmbezirk = as.numeric(nummer))
afd_votes <-
glue::glue(
"https://www.stadt-koeln.de/wahlen/bundestagswahl/09-2021/praesentation/\\
Open-Data-Bundestagswahl476.csv"
) %>%
readr::read_csv2() %>%
dplyr::transmute(Stimmbezirk = `gebiet-nr`, afd_share = (F1 / F) * 100)
election_results <-
dplyr::left_join(
voting_districts,
afd_votes,
by = "Stimmbezirk"
)
immigrants_cologne <-
z11::z11_get_100m_attribute(STAATSANGE_KURZ_2) %>%
terra::crop(election_results) %>%
terra::mask(terra::vect(election_results))
inhabitants_cologne <-
z11::z11_get_100m_attribute(Einwohner) %>%
terra::crop(election_results) %>%
terra::mask(terra::vect(election_results))
immigrant_share_cologne <-
(immigrants_cologne / inhabitants_cologne) * 100
election_results <-
election_results %>%
dplyr::mutate(
immigrant_share =
exactextractr::exact_extract(immigrant_share_cologne, ., 'mean'),
inhabitants =
exactextractr::exact_extract(inhabitants_cologne, ., 'mean')
)
style = "minmax" in the spdep:nb2listw() function.
# spdep
queen_neighborhood <-
spdep::poly2nb(
election_results,
queen = TRUE
)
queen_W <- spdep::nb2listw(queen_neighborhood, style = "W")
queen_minmax <- spdep::nb2listw(queen_neighborhood, style = "minmax")
# run regressions
spatial_lag_y_W <-
spatialreg::lagsarlm(
afd_share ~ immigrant_share + inhabitants,
data = election_results,
listw = queen_W
)
spatial_lag_y_minmax <-
spatialreg::lagsarlm(
afd_share ~ immigrant_share + inhabitants,
data = election_results,
listw = queen_minmax
)
spatialreg::impacts(spatial_lag_y_W, listw = queen_W)
## Impact measures (lag, exact):
## Direct Indirect Total
## immigrant_share -0.05999312 -0.09788693 -0.15788005
## inhabitants -0.03747085 -0.06113877 -0.09860962
spatialreg::impacts(spatial_lag_y_minmax, listw = rook_W)
## Impact measures (lag, exact):
## Direct Indirect Total
## immigrant_share -0.11174858 -0.08429008 -0.1960387
## inhabitants -0.06714851 -0.05064900 -0.1177975
# There are some slight differences in the estimate of the indirect effects but
# more severe one in the calculation of the direct ones.